package us.wili.dev.model.example;

import java.math.BigDecimal;
import java.time.LocalDateTime;
import java.util.ArrayList;
import java.util.List;

public class GoodsExample {
    protected Order order;

    protected boolean distinct;

    protected String lock;

    protected List oredCriteria;

    protected Selector selector;

    protected Limit limit;

    public GoodsExample() {
        oredCriteria = new ArrayList<>();
        distinct = false;
        lock = "";
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public String getLock() {
        return lock;
    }

    public List getOredCriteria() {
        return oredCriteria;
    }

    public Selector getSelector() {
        return selector;
    }

    public Limit getLimit() {
        return limit;
    }

    public Selector select() {
        selector = new Selector();
        return selector;
    }

    public Order orderBy() {
        order = new Order();
        return order;
    }

    public void limit(int rowCount) {
        limit = new Limit(rowCount);
    }

    public void limit(int offset, int rowCount) {
        limit = new Limit(offset, rowCount);
    }

    public void forUpdate() {
        lock = "for update";
    }

    public void lockInShareMode() {
        lock = "lock in share mode";
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = new Criteria();
        oredCriteria.add(new Criteria());
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = new Criteria();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        distinct = false;
    }

    public void clearLock() {
        lock = "";
    }

    public void clearLimit() {
        limit = null;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                return;
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value) {
            if (value == null) {
                return;
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2) {
            if (value1 == null || value2 == null) {
                return;
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdEqualTo(Long value) {
            addCriterion("`id` =", value);
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(Long value) {
            addCriterion("`id` <>", value);
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(Long value) {
            addCriterion("`id` >", value);
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(Long value) {
            addCriterion("`id` >=", value);
            return (Criteria) this;
        }

        public Criteria andIdLessThan(Long value) {
            addCriterion("`id` <", value);
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(Long value) {
            addCriterion("`id` <=", value);
            return (Criteria) this;
        }

        public Criteria andIdIn(List<Long> values) {
            addCriterion("`id` in ", values);
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<Long> values) {
            addCriterion("`id` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andIdBetween(Long value1, Long value2) {
            addCriterion("`id` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(Long value1, Long value2) {
            addCriterion("`id` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsNameIsNull() {
            addCriterion("`goods_name` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsNameIsNotNull() {
            addCriterion("`goods_name` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsNameEqualTo(String value) {
            addCriterion("`goods_name` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotEqualTo(String value) {
            addCriterion("`goods_name` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNameGreaterThan(String value) {
            addCriterion("`goods_name` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNameGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_name` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNameLessThan(String value) {
            addCriterion("`goods_name` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNameLessThanOrEqualTo(String value) {
            addCriterion("`goods_name` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNameLike(String value) {
            addCriterion("`goods_name` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotLike(String value) {
            addCriterion("`goods_name` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNameIn(List<String> values) {
            addCriterion("`goods_name` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotIn(List<String> values) {
            addCriterion("`goods_name` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsNameBetween(String value1, String value2) {
            addCriterion("`goods_name` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsNameNotBetween(String value1, String value2) {
            addCriterion("`goods_name` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsPicIsNull() {
            addCriterion("`goods_pic` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsPicIsNotNull() {
            addCriterion("`goods_pic` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsPicEqualTo(String value) {
            addCriterion("`goods_pic` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPicNotEqualTo(String value) {
            addCriterion("`goods_pic` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPicGreaterThan(String value) {
            addCriterion("`goods_pic` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPicGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_pic` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPicLessThan(String value) {
            addCriterion("`goods_pic` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPicLessThanOrEqualTo(String value) {
            addCriterion("`goods_pic` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPicLike(String value) {
            addCriterion("`goods_pic` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPicNotLike(String value) {
            addCriterion("`goods_pic` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPicIn(List<String> values) {
            addCriterion("`goods_pic` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsPicNotIn(List<String> values) {
            addCriterion("`goods_pic` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsPicBetween(String value1, String value2) {
            addCriterion("`goods_pic` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsPicNotBetween(String value1, String value2) {
            addCriterion("`goods_pic` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceIsNull() {
            addCriterion("`goods_price` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceIsNotNull() {
            addCriterion("`goods_price` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsPriceEqualTo(BigDecimal value) {
            addCriterion("`goods_price` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceNotEqualTo(BigDecimal value) {
            addCriterion("`goods_price` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceGreaterThan(BigDecimal value) {
            addCriterion("`goods_price` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("`goods_price` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceLessThan(BigDecimal value) {
            addCriterion("`goods_price` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceLessThanOrEqualTo(BigDecimal value) {
            addCriterion("`goods_price` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceIn(List<BigDecimal> values) {
            addCriterion("`goods_price` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceNotIn(List<BigDecimal> values) {
            addCriterion("`goods_price` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("`goods_price` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsPriceNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("`goods_price` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsBigIsNull() {
            addCriterion("`goods_big` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsBigIsNotNull() {
            addCriterion("`goods_big` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsBigEqualTo(String value) {
            addCriterion("`goods_big` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsBigNotEqualTo(String value) {
            addCriterion("`goods_big` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsBigGreaterThan(String value) {
            addCriterion("`goods_big` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsBigGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_big` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsBigLessThan(String value) {
            addCriterion("`goods_big` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsBigLessThanOrEqualTo(String value) {
            addCriterion("`goods_big` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsBigLike(String value) {
            addCriterion("`goods_big` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsBigNotLike(String value) {
            addCriterion("`goods_big` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsBigIn(List<String> values) {
            addCriterion("`goods_big` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsBigNotIn(List<String> values) {
            addCriterion("`goods_big` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsBigBetween(String value1, String value2) {
            addCriterion("`goods_big` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsBigNotBetween(String value1, String value2) {
            addCriterion("`goods_big` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoIsNull() {
            addCriterion("`goods_cargo` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsCargoIsNotNull() {
            addCriterion("`goods_cargo` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsCargoEqualTo(String value) {
            addCriterion("`goods_cargo` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoNotEqualTo(String value) {
            addCriterion("`goods_cargo` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoGreaterThan(String value) {
            addCriterion("`goods_cargo` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_cargo` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoLessThan(String value) {
            addCriterion("`goods_cargo` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoLessThanOrEqualTo(String value) {
            addCriterion("`goods_cargo` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoLike(String value) {
            addCriterion("`goods_cargo` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoNotLike(String value) {
            addCriterion("`goods_cargo` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoIn(List<String> values) {
            addCriterion("`goods_cargo` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoNotIn(List<String> values) {
            addCriterion("`goods_cargo` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoBetween(String value1, String value2) {
            addCriterion("`goods_cargo` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsCargoNotBetween(String value1, String value2) {
            addCriterion("`goods_cargo` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsColorIsNull() {
            addCriterion("`goods_color` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsColorIsNotNull() {
            addCriterion("`goods_color` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsColorEqualTo(Integer value) {
            addCriterion("`goods_color` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsColorNotEqualTo(Integer value) {
            addCriterion("`goods_color` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsColorGreaterThan(Integer value) {
            addCriterion("`goods_color` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsColorGreaterThanOrEqualTo(Integer value) {
            addCriterion("`goods_color` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsColorLessThan(Integer value) {
            addCriterion("`goods_color` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsColorLessThanOrEqualTo(Integer value) {
            addCriterion("`goods_color` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsColorIn(List<Integer> values) {
            addCriterion("`goods_color` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsColorNotIn(List<Integer> values) {
            addCriterion("`goods_color` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsColorBetween(Integer value1, Integer value2) {
            addCriterion("`goods_color` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsColorNotBetween(Integer value1, Integer value2) {
            addCriterion("`goods_color` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberIsNull() {
            addCriterion("`goods_number` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsNumberIsNotNull() {
            addCriterion("`goods_number` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsNumberEqualTo(String value) {
            addCriterion("`goods_number` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberNotEqualTo(String value) {
            addCriterion("`goods_number` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberGreaterThan(String value) {
            addCriterion("`goods_number` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_number` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberLessThan(String value) {
            addCriterion("`goods_number` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberLessThanOrEqualTo(String value) {
            addCriterion("`goods_number` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberLike(String value) {
            addCriterion("`goods_number` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberNotLike(String value) {
            addCriterion("`goods_number` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberIn(List<String> values) {
            addCriterion("`goods_number` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberNotIn(List<String> values) {
            addCriterion("`goods_number` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberBetween(String value1, String value2) {
            addCriterion("`goods_number` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsNumberNotBetween(String value1, String value2) {
            addCriterion("`goods_number` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsWideIsNull() {
            addCriterion("`goods_wide` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsWideIsNotNull() {
            addCriterion("`goods_wide` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsWideEqualTo(String value) {
            addCriterion("`goods_wide` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsWideNotEqualTo(String value) {
            addCriterion("`goods_wide` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsWideGreaterThan(String value) {
            addCriterion("`goods_wide` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsWideGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_wide` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsWideLessThan(String value) {
            addCriterion("`goods_wide` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsWideLessThanOrEqualTo(String value) {
            addCriterion("`goods_wide` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsWideLike(String value) {
            addCriterion("`goods_wide` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsWideNotLike(String value) {
            addCriterion("`goods_wide` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsWideIn(List<String> values) {
            addCriterion("`goods_wide` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsWideNotIn(List<String> values) {
            addCriterion("`goods_wide` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsWideBetween(String value1, String value2) {
            addCriterion("`goods_wide` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsWideNotBetween(String value1, String value2) {
            addCriterion("`goods_wide` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonIsNull() {
            addCriterion("`goods_season` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonIsNotNull() {
            addCriterion("`goods_season` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonEqualTo(String value) {
            addCriterion("`goods_season` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonNotEqualTo(String value) {
            addCriterion("`goods_season` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonGreaterThan(String value) {
            addCriterion("`goods_season` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_season` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonLessThan(String value) {
            addCriterion("`goods_season` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonLessThanOrEqualTo(String value) {
            addCriterion("`goods_season` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonLike(String value) {
            addCriterion("`goods_season` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonNotLike(String value) {
            addCriterion("`goods_season` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonIn(List<String> values) {
            addCriterion("`goods_season` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonNotIn(List<String> values) {
            addCriterion("`goods_season` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonBetween(String value1, String value2) {
            addCriterion("`goods_season` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsSeasonNotBetween(String value1, String value2) {
            addCriterion("`goods_season` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsGIsNull() {
            addCriterion("`goods_g` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsGIsNotNull() {
            addCriterion("`goods_g` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsGEqualTo(String value) {
            addCriterion("`goods_g` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsGNotEqualTo(String value) {
            addCriterion("`goods_g` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsGGreaterThan(String value) {
            addCriterion("`goods_g` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsGGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_g` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsGLessThan(String value) {
            addCriterion("`goods_g` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsGLessThanOrEqualTo(String value) {
            addCriterion("`goods_g` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsGLike(String value) {
            addCriterion("`goods_g` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsGNotLike(String value) {
            addCriterion("`goods_g` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsGIn(List<String> values) {
            addCriterion("`goods_g` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsGNotIn(List<String> values) {
            addCriterion("`goods_g` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsGBetween(String value1, String value2) {
            addCriterion("`goods_g` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsGNotBetween(String value1, String value2) {
            addCriterion("`goods_g` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsUseIsNull() {
            addCriterion("`goods_use` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsUseIsNotNull() {
            addCriterion("`goods_use` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsUseEqualTo(String value) {
            addCriterion("`goods_use` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsUseNotEqualTo(String value) {
            addCriterion("`goods_use` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsUseGreaterThan(String value) {
            addCriterion("`goods_use` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsUseGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_use` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsUseLessThan(String value) {
            addCriterion("`goods_use` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsUseLessThanOrEqualTo(String value) {
            addCriterion("`goods_use` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsUseLike(String value) {
            addCriterion("`goods_use` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsUseNotLike(String value) {
            addCriterion("`goods_use` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsUseIn(List<String> values) {
            addCriterion("`goods_use` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsUseNotIn(List<String> values) {
            addCriterion("`goods_use` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsUseBetween(String value1, String value2) {
            addCriterion("`goods_use` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsUseNotBetween(String value1, String value2) {
            addCriterion("`goods_use` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialIsNull() {
            addCriterion("`goods_material` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialIsNotNull() {
            addCriterion("`goods_material` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialEqualTo(Integer value) {
            addCriterion("`goods_material` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialNotEqualTo(Integer value) {
            addCriterion("`goods_material` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialGreaterThan(Integer value) {
            addCriterion("`goods_material` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialGreaterThanOrEqualTo(Integer value) {
            addCriterion("`goods_material` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialLessThan(Integer value) {
            addCriterion("`goods_material` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialLessThanOrEqualTo(Integer value) {
            addCriterion("`goods_material` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialIn(List<Integer> values) {
            addCriterion("`goods_material` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialNotIn(List<Integer> values) {
            addCriterion("`goods_material` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialBetween(Integer value1, Integer value2) {
            addCriterion("`goods_material` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsMaterialNotBetween(Integer value1, Integer value2) {
            addCriterion("`goods_material` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesIsNull() {
            addCriterion("`goods_images` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsImagesIsNotNull() {
            addCriterion("`goods_images` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsImagesEqualTo(String value) {
            addCriterion("`goods_images` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesNotEqualTo(String value) {
            addCriterion("`goods_images` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesGreaterThan(String value) {
            addCriterion("`goods_images` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesGreaterThanOrEqualTo(String value) {
            addCriterion("`goods_images` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesLessThan(String value) {
            addCriterion("`goods_images` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesLessThanOrEqualTo(String value) {
            addCriterion("`goods_images` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesLike(String value) {
            addCriterion("`goods_images` like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesNotLike(String value) {
            addCriterion("`goods_images` not like", value);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesIn(List<String> values) {
            addCriterion("`goods_images` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesNotIn(List<String> values) {
            addCriterion("`goods_images` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesBetween(String value1, String value2) {
            addCriterion("`goods_images` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsImagesNotBetween(String value1, String value2) {
            addCriterion("`goods_images` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCreatedAtEqualTo(LocalDateTime value) {
            addCriterion("`created_at` =", value);
            return (Criteria) this;
        }

        public Criteria andCreatedAtNotEqualTo(LocalDateTime value) {
            addCriterion("`created_at` <>", value);
            return (Criteria) this;
        }

        public Criteria andCreatedAtGreaterThan(LocalDateTime value) {
            addCriterion("`created_at` >", value);
            return (Criteria) this;
        }

        public Criteria andCreatedAtGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("`created_at` >=", value);
            return (Criteria) this;
        }

        public Criteria andCreatedAtLessThan(LocalDateTime value) {
            addCriterion("`created_at` <", value);
            return (Criteria) this;
        }

        public Criteria andCreatedAtLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("`created_at` <=", value);
            return (Criteria) this;
        }

        public Criteria andCreatedAtIn(List<LocalDateTime> values) {
            addCriterion("`created_at` in ", values);
            return (Criteria) this;
        }

        public Criteria andCreatedAtNotIn(List<LocalDateTime> values) {
            addCriterion("`created_at` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andCreatedAtBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("`created_at` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andCreatedAtNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("`created_at` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtEqualTo(LocalDateTime value) {
            addCriterion("`updated_at` =", value);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtNotEqualTo(LocalDateTime value) {
            addCriterion("`updated_at` <>", value);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtGreaterThan(LocalDateTime value) {
            addCriterion("`updated_at` >", value);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtGreaterThanOrEqualTo(LocalDateTime value) {
            addCriterion("`updated_at` >=", value);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtLessThan(LocalDateTime value) {
            addCriterion("`updated_at` <", value);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtLessThanOrEqualTo(LocalDateTime value) {
            addCriterion("`updated_at` <=", value);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtIn(List<LocalDateTime> values) {
            addCriterion("`updated_at` in ", values);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtNotIn(List<LocalDateTime> values) {
            addCriterion("`updated_at` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("`updated_at` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andUpdatedAtNotBetween(LocalDateTime value1, LocalDateTime value2) {
            addCriterion("`updated_at` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andVersionIsNull() {
            addCriterion("`version` is null");
            return (Criteria) this;
        }

        public Criteria andVersionIsNotNull() {
            addCriterion("`version` is not null");
            return (Criteria) this;
        }

        public Criteria andVersionEqualTo(Long value) {
            addCriterion("`version` =", value);
            return (Criteria) this;
        }

        public Criteria andVersionNotEqualTo(Long value) {
            addCriterion("`version` <>", value);
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThan(Long value) {
            addCriterion("`version` >", value);
            return (Criteria) this;
        }

        public Criteria andVersionGreaterThanOrEqualTo(Long value) {
            addCriterion("`version` >=", value);
            return (Criteria) this;
        }

        public Criteria andVersionLessThan(Long value) {
            addCriterion("`version` <", value);
            return (Criteria) this;
        }

        public Criteria andVersionLessThanOrEqualTo(Long value) {
            addCriterion("`version` <=", value);
            return (Criteria) this;
        }

        public Criteria andVersionIn(List<Long> values) {
            addCriterion("`version` in ", values);
            return (Criteria) this;
        }

        public Criteria andVersionNotIn(List<Long> values) {
            addCriterion("`version` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andVersionBetween(Long value1, Long value2) {
            addCriterion("`version` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andVersionNotBetween(Long value1, Long value2) {
            addCriterion("`version` not between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityIsNull() {
            addCriterion("`goods_activity` is null");
            return (Criteria) this;
        }

        public Criteria andGoodsActivityIsNotNull() {
            addCriterion("`goods_activity` is not null");
            return (Criteria) this;
        }

        public Criteria andGoodsActivityEqualTo(Integer value) {
            addCriterion("`goods_activity` =", value);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityNotEqualTo(Integer value) {
            addCriterion("`goods_activity` <>", value);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityGreaterThan(Integer value) {
            addCriterion("`goods_activity` >", value);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityGreaterThanOrEqualTo(Integer value) {
            addCriterion("`goods_activity` >=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityLessThan(Integer value) {
            addCriterion("`goods_activity` <", value);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityLessThanOrEqualTo(Integer value) {
            addCriterion("`goods_activity` <=", value);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityIn(List<Integer> values) {
            addCriterion("`goods_activity` in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityNotIn(List<Integer> values) {
            addCriterion("`goods_activity` not  in ", values);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityBetween(Integer value1, Integer value2) {
            addCriterion("`goods_activity` between", value1, value2);
            return (Criteria) this;
        }

        public Criteria andGoodsActivityNotBetween(Integer value1, Integer value2) {
            addCriterion("`goods_activity` not between", value1, value2);
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }

    public static class Selector {
        private List<String> columns = new ArrayList<>();

        public int getSize() {
            return columns.size();
        }

        public Selector addWithAlias(String column) {
            columns.add(column+ "AS `" + column + "`");
            return this;
        }

        public List<String> getColumns() {
            return columns;
        }

        public Selector id() {
            columns.add("goods.id");
            return this;
        }

        public Selector goodsName() {
            columns.add("goods.goods_name");
            return this;
        }

        public Selector goodsPic() {
            columns.add("goods.goods_pic");
            return this;
        }

        public Selector goodsPrice() {
            columns.add("goods.goods_price");
            return this;
        }

        public Selector goodsBig() {
            columns.add("goods.goods_big");
            return this;
        }

        public Selector goodsCargo() {
            columns.add("goods.goods_cargo");
            return this;
        }

        public Selector goodsColor() {
            columns.add("goods.goods_color");
            return this;
        }

        public Selector goodsNumber() {
            columns.add("goods.goods_number");
            return this;
        }

        public Selector goodsWide() {
            columns.add("goods.goods_wide");
            return this;
        }

        public Selector goodsSeason() {
            columns.add("goods.goods_season");
            return this;
        }

        public Selector goodsG() {
            columns.add("goods.goods_g");
            return this;
        }

        public Selector goodsUse() {
            columns.add("goods.goods_use");
            return this;
        }

        public Selector goodsMaterial() {
            columns.add("goods.goods_material");
            return this;
        }

        public Selector goodsImages() {
            columns.add("goods.goods_images");
            return this;
        }

        public Selector createdAt() {
            columns.add("goods.created_at");
            return this;
        }

        public Selector updatedAt() {
            columns.add("goods.updated_at");
            return this;
        }

        public Selector version() {
            columns.add("goods.version");
            return this;
        }

        public Selector goodsActivity() {
            columns.add("goods.goods_activity");
            return this;
        }

        public Selector goodsDeta() {
            columns.add("goods.goods_deta");
            return this;
        }

        public void clear() {
            columns.clear();
        }
    }

    public static class Order {
        private List<String> columns = new ArrayList<>();

        public int getSize() {
            return columns.size();
        }

        public List<String> getColumns() {
            return columns;
        }

        public Order add(String clause) {
            columns.add(clause);
            return this;
        }

        public Order ascId() {
            columns.add("goods.id ASC");
            return this;
        }

        public Order descId() {
            columns.add("goods.id DESC");
            return this;
        }

        public Order ascGoodsName() {
            columns.add("goods.goods_name ASC");
            return this;
        }

        public Order descGoodsName() {
            columns.add("goods.goods_name DESC");
            return this;
        }

        public Order ascGoodsPic() {
            columns.add("goods.goods_pic ASC");
            return this;
        }

        public Order descGoodsPic() {
            columns.add("goods.goods_pic DESC");
            return this;
        }

        public Order ascGoodsPrice() {
            columns.add("goods.goods_price ASC");
            return this;
        }

        public Order descGoodsPrice() {
            columns.add("goods.goods_price DESC");
            return this;
        }

        public Order ascGoodsBig() {
            columns.add("goods.goods_big ASC");
            return this;
        }

        public Order descGoodsBig() {
            columns.add("goods.goods_big DESC");
            return this;
        }

        public Order ascGoodsCargo() {
            columns.add("goods.goods_cargo ASC");
            return this;
        }

        public Order descGoodsCargo() {
            columns.add("goods.goods_cargo DESC");
            return this;
        }

        public Order ascGoodsColor() {
            columns.add("goods.goods_color ASC");
            return this;
        }

        public Order descGoodsColor() {
            columns.add("goods.goods_color DESC");
            return this;
        }

        public Order ascGoodsNumber() {
            columns.add("goods.goods_number ASC");
            return this;
        }

        public Order descGoodsNumber() {
            columns.add("goods.goods_number DESC");
            return this;
        }

        public Order ascGoodsWide() {
            columns.add("goods.goods_wide ASC");
            return this;
        }

        public Order descGoodsWide() {
            columns.add("goods.goods_wide DESC");
            return this;
        }

        public Order ascGoodsSeason() {
            columns.add("goods.goods_season ASC");
            return this;
        }

        public Order descGoodsSeason() {
            columns.add("goods.goods_season DESC");
            return this;
        }

        public Order ascGoodsG() {
            columns.add("goods.goods_g ASC");
            return this;
        }

        public Order descGoodsG() {
            columns.add("goods.goods_g DESC");
            return this;
        }

        public Order ascGoodsUse() {
            columns.add("goods.goods_use ASC");
            return this;
        }

        public Order descGoodsUse() {
            columns.add("goods.goods_use DESC");
            return this;
        }

        public Order ascGoodsMaterial() {
            columns.add("goods.goods_material ASC");
            return this;
        }

        public Order descGoodsMaterial() {
            columns.add("goods.goods_material DESC");
            return this;
        }

        public Order ascGoodsImages() {
            columns.add("goods.goods_images ASC");
            return this;
        }

        public Order descGoodsImages() {
            columns.add("goods.goods_images DESC");
            return this;
        }

        public Order ascCreatedAt() {
            columns.add("goods.created_at ASC");
            return this;
        }

        public Order descCreatedAt() {
            columns.add("goods.created_at DESC");
            return this;
        }

        public Order ascUpdatedAt() {
            columns.add("goods.updated_at ASC");
            return this;
        }

        public Order descUpdatedAt() {
            columns.add("goods.updated_at DESC");
            return this;
        }

        public Order ascVersion() {
            columns.add("goods.version ASC");
            return this;
        }

        public Order descVersion() {
            columns.add("goods.version DESC");
            return this;
        }

        public Order ascGoodsActivity() {
            columns.add("goods.goods_activity ASC");
            return this;
        }

        public Order descGoodsActivity() {
            columns.add("goods.goods_activity DESC");
            return this;
        }

        public Order ascGoodsDeta() {
            columns.add("goods.goods_deta ASC");
            return this;
        }

        public Order descGoodsDeta() {
            columns.add("goods.goods_deta DESC");
            return this;
        }

        public void clear() {
            columns.clear();
        }
    }

    public static class Limit {
        private int offset;

        private int rowCount;

        private boolean isLmtRow;

        public int getOffset() {
            return offset;
        }

        public int getRowCount() {
            return rowCount;
        }

        public boolean isIsLmtRow() {
            return isLmtRow;
        }

        public Limit(int rowCount) {
            this.rowCount = rowCount; 
            isLmtRow = false;
        }

        public Limit(int offset, int rowCount) {
            this.offset = offset; 
            this.rowCount = rowCount;
            isLmtRow = true;
        }
    }
}